SELECT FORMMAIN_0043.field0101 as 采购编号,FORMMAIN_0043.field0007 as BT,FORMMAIN_0043.FIELD0004 as DJBH,
ORG_MEMBER.NAME as USERNAME,"temp_org_member_group"."company" as ADDRESS,ORG_UNIT.NAME as DEPTNAME
FROM FORMSON_0044
LEFT OUTER JOIN FORMMAIN_0043 ON FORMSON_0044.FORMMAIN_ID=FORMMAIN_0043.ID
LEFT outer JOIN ORG_MEMBER ON ORG_MEMBER.ID = FORMMAIN_0043.field0001
LEFT outer JOIN "temp_org_member_group" ON ORG_MEMBER.ID = "temp_org_member_group"."member_id"
LEFT outer JOIN ORG_UNIT ON ORG_MEMBER.ORG_DEPARTMENT_ID = ORG_UNIT."ID" 
WHERE FORMSON_0044.FORMMAIN_ID=?